<?php 
	include_once 'thuvienham.php';
	include_once 'hocvien_db.php';

	class hocvien_bs 
	{
		//------------------Fields [18]------------------
			// #0
		private $MaHocVien = "";
		public function SetMaHocVien($MaHocVien)           { $this->MaHocVien = $MaHocVien;           }
		public function GetMaHocVien()                     { return $this->MaHocVien;                 }
			// #1
		private $MaLopHoc = "";
		public function SetMaLopHoc($MaLopHoc)             { $this->MaLopHoc = $MaLopHoc;             }
		public function GetMaLopHoc()                      { return $this->MaLopHoc;                  }
			// #2
		private $MaChuongTrinh = "";
		public function SetMaChuongTrinh($MaChuongTrinh)   { $this->MaChuongTrinh = $MaChuongTrinh;   }
		public function GetMaChuongTrinh()                 { return $this->MaChuongTrinh;             }
			// #3
		private $MaThoiGianHoc = "";
		public function SetMaThoiGianHoc($MaThoiGianHoc)   { $this->MaThoiGianHoc = $MaThoiGianHoc;   }
		public function GetMaThoiGianHoc()                 { return $this->MaThoiGianHoc;             }
			// #4
		private $HoTen = "";
		public function SetHoTen($HoTen)                   { $this->HoTen = $HoTen;                   }
		public function GetHoTen()                         { return $this->HoTen;                     }
			// #5
		private $NgaySinh = "0000-00-00";
		public function SetNgaySinh($NgaySinh)             { $this->NgaySinh = $NgaySinh;             }
		public function GetNgaySinh()                      { return $this->NgaySinh;                  }
			// #6
		private $GioiTinh = -1;
		public function SetGioiTinh($GioiTinh)             { $this->GioiTinh = $GioiTinh;             }
		public function GetGioiTinh()                      { return $this->GioiTinh;                  }
		
			// #7
		private $DiaChi = "";
		public function SetDiaChi($DiaChi)                 { $this->DiaChi = $DiaChi;                 }
		public function GetDiaChi()                        { return $this->DiaChi;                    }
			// #8
		private $DienThoai = "";
		public function SetDienThoai($DienThoai)           { $this->DienThoai = $DienThoai;           }
		public function GetDienThoai()                     { return $this->DienThoai;                 }
			// #9
		private $Email = "";
		public function SetEmail($Email)                   { $this->Email = $Email;                   }
		public function GetEmail()                         { return $this->Email;                     }
			// #10
		private $Lop = "";
		public function SetLop($Lop)                       { $this->Lop = $Lop;                       }
		public function GetLop()                           { return $this->Lop;                       }
			// #11
		private $SoMay = "";
		public function SetSoMay($SoMay)                   { $this->SoMay = $SoMay;                   }
		public function GetSoMay()                         { return $this->SoMay;                     }
			// #12
		private $NgayDangKy = "0000-00-00";
		public function SetNgayDangKy($NgayDangKy)         { $this->NgayDangKy = $NgayDangKy;         }
		public function GetNgayDangKy()                    { return $this->NgayDangKy;                }
			// #13
		private $MaTrangThai = -1;
		public function SetMaTrangThai($MaTrangThai)       { $this->MaTrangThai = $MaTrangThai;       }
		public function GetMaTrangThai()                   { return $this->MaTrangThai;               }
			// #14
		private $PIN = "";
		public function SetPIN($PIN)                       { $this->PIN = $PIN;                       }
		public function GetPIN()                           { return $this->PIN;                       }
			// #15
		private $HocPhiDuocGiam = -1;
		public function SetHocPhiDuocGiam($HocPhiDuocGiam) { $this->HocPhiDuocGiam = $HocPhiDuocGiam; }
		public function GetHocPhiDuocGiam()                { return $this->HocPhiDuocGiam;            }
			// #16
		private $HocPhiDaNop = -1;
		public function SetHocPhiDaNop($HocPhiDaNop)       { $this->HocPhiDaNop = $HocPhiDaNop;       }
		public function GetHocPhiDaNop()                   { return $this->HocPhiDaNop;               }
			// #17
		private $DaXoa = -1;
		public function SetDaXoa($DaXoa)                   { $this->DaXoa = $DaXoa;                   }
		public function GetDaXoa()                         { return $this->DaXoa;                     }

		//------------------Method------------------
		public function Them()
		{
			$data = new hocvien_db();
			return $data->Them($this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa);
		}

		public function Xoa()
		{
			$data = new hocvien_db();
			return $data->Xoa($this->MaHocVien);
		}

		public function CapNhat()
		{
			$data = new hocvien_db();
			return $data->CapNhat($this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa);
		}

		public function LayDanhSach()
		{
			$data = new hocvien_db();
			return $data->LayDanhSach($this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa);
		}
		
		public function LayDanhSachPaging($Start, $Limit)
		{
			$data = new hocvien_db();
			return $data->LayDanhSachPaging($this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa, $Start, $Limit);
		}
		
		public function LSDMaHocVienTheoKhoa($MaKhoaHoc)
		{
			$data = new hocvien_db();
			return $data->LSDMaHocVienTheoKhoa($this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa, $MaKhoaHoc);
		}
		public function HocVienTrongKhoa($MaKhoaHoc)
		{
			$data = new hocvien_db();
			return $data->HocVienTrongKhoa($this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa, $MaKhoaHoc);
		}
		
		public function CapNhatPIN()
		{
			$data = new hocvien_db();
			return $data->CapNhatPIN($this->MaHocVien, $this->PIN);
		}
		public function DanhSachHocVienCanThuHocPhi()
		{
			$data = new hocvien_db();
			return $data->DanhSachHocVienCanThuHocPhi($this->HoTen);
		}
		public function DanhSachHocVienCanThuHocPhiPaging($Start, $Limit)
		{
			$data = new hocvien_db();
			return $data->DanhSachHocVienCanThuHocPhiPaging($this->HoTen, $Start, $Limit);
		}
		public function Trash()
		{
			$data = new hocvien_db();
			return $data->Trash($this->MaHocVien, $this->DaXoa);
		}
		public function NopHocPhi()
		{
			$data = new hocvien_db();
			return $data->NopHocPhi($this->MaHocVien, $this->HocPhiDaNop);
		}
		public function DSHVTheoKhoa($MaKhoa)
		{
			$data = new hocvien_db();
			return $data->DSHVTheoKhoa($MaKhoa, $this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa);
		}
		public function DSHVTheoKhoaPaging($MaKhoa, $Start, $Limit)
		{
			$data = new hocvien_db();
			return $data->DSHVTheoKhoaPaging($MaKhoa, $this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa, $Start, $Limit);
		}
		
		public function LayDanhSachSapXepTheoTen() // Danh sách được sắp xếp theo Tên trong họ tên
		{
			$data = new hocvien_db();
			return $data->LayDanhSachSapXepTheoTen($this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa);
		}
		
		public function LayDanhSachSapXepTheoSoMay() // Lấy sanh sách cho phát sinh mã học viện tự động tăng dần
		{
			$data = new hocvien_db();
			return $data->LayDanhSachSapXepTheoSoMay($this->MaHocVien, $this->MaLopHoc, $this->MaChuongTrinh, $this->MaThoiGianHoc, $this->HoTen, $this->NgaySinh, $this->GioiTinh, $this->DiaChi, $this->DienThoai, $this->Email, $this->Lop, $this->SoMay, $this->NgayDangKy, $this->MaTrangThai, $this->PIN, $this->HocPhiDuocGiam, $this->HocPhiDaNop, $this->DaXoa);
		}
		
	}
